Skip to main content
TrustRadius
Microsoft SQL Server

Microsoft SQL Server

Overview

What is Microsoft SQL Server?

Microsoft SQL Server is a relational database.

Read more
Recent Reviews

Solid and Reliable.

10 out of 10
August 28, 2023
Incentivized
We use MSSQL Server along with SSIS and SSRS as it's a very competent software suite and very stable. It integrates well with other …
Continue reading

Microsoft SQL Server Review

9 out of 10
October 28, 2022
I am a computer engineer. I have been working as a software developer for about 7 years. I've been using Microsoft SQL Server since I was …
Continue reading

SQL Server Review

8 out of 10
June 19, 2021
Incentivized
We use MS SQL Server as our main database to store customer data. We have a monolith web application that is using a single MS SQL Server …
Continue reading

MS SQL Server

8 out of 10
May 25, 2021
Incentivized
For the uninitiated it is first important to point out that many programs use a Database at the back-end and the end-user will be totally …
Continue reading
Read all reviews

Awards

Products that are considered exceptional by their customers based on a variety of criteria win TrustRadius awards. Learn more about the types of TrustRadius awards to make the best purchase decision. More about TrustRadius Awards

Reviewer Pros & Cons

View all pros & cons
Return to navigation

Pricing

View all pricing

Subscription

$1,418.00

Cloud
Per License

Enterprise

$13,748.00

Cloud
Per License

Entry-level set up fee?

  • No setup fee

Offerings

  • Free Trial
  • Free/Freemium Version
  • Premium Consulting/Integration Services
Return to navigation

Product Demos

An Introduction to Microsoft SQL Server's Statistics

YouTube

Introduction to Transact SQL (T-SQL) using Microsoft SQL Server

YouTube
Return to navigation

Product Details

What is Microsoft SQL Server?

Microsoft SQL Server Video

Microsoft SQL Server Technical Details

Deployment TypesSoftware as a Service (SaaS), Cloud, or Web-Based
Operating SystemsUnspecified
Mobile ApplicationNo

Frequently Asked Questions

Microsoft SQL Server is a relational database.

Reviewers rate Usability highest, with a score of 9.9.

The most common users of Microsoft SQL Server are from Mid-sized Companies (51-1,000 employees).
Return to navigation

Comparisons

View all alternatives
Return to navigation

Reviews and Ratings

(1608)

Attribute Ratings

Reviews

(1-25 of 63)
Companies can't remove reviews or game the system. Here's why
Score 9 out of 10
Vetted Review
Verified User
I am a computer engineer. I have been working as a software developer for about 7 years. I've been using Microsoft SQL Server since I was a student. The interface is very simple and useful, even beginners can use it comfortably. The dark theme has no shortcomings except that it is added under options. Table, schema, and index adding operations can be handled with a single line.
  • Ease of learning
  • Simple design
  • Common use
  • Documentation
  • Dark theme
  • Improvement of the query plan
  • Output screen is white
I'm making bank software and I can use Microsoft SQL Server for all scenarios. Customer data, account data, card data, credit data all information is kept in the Microsoft SQL Server database. It provides convenience while keeping related data. While reporting, slowness may occur because there is too much data. We use Oracle as an equivalent.
Gordon Lo | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use SQL server as a back-end for the vast majority of our software applications. This includes backends for web apps, data staging and SSIS/SSRS. As far as DB's go, SQL server is our first choice because it integrates easily with our Microsoft .net and .net core applications. Our SQL DB's are used across the entire organization.
  • high volume transactions
  • data staging and bulk data loads
  • integration to active directory
  • ease of setup
  • it's still a memory hog, but that's gotten better since 2016
  • it can be expensive to license
If your organization builds a lot of Microsoft based applications using .net or .net core, then the use of SQL is a no-brainer. The integration with .net is second to none as a backend for web apps and APIs.

In general, SQL performs well for a multitude of tasks beyond web app backends. We use SQL for high volume transactions for our core ESB which has very high data volume and data churn.
Pritesh Patel | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We currently use Microsoft SQL Server as our database application for our applications. We are using the Microsoft SQL Server jobs, Analysis services, cubes, and many other features to help provide front end data solutions to our customers. Our instance of Microsoft SQL Server also allows for multi-database implementation with full backup capabilities. We also pair with the latest management studio to get the best UI experience.
  • Easy to use with Visual Studio and ASP projects
  • Multiple options for Data Security
  • Industry standard and easy to use
  • Easy to install and configure
  • Licensing can get complicated
  • Very very expensive
  • combability issues and dependencies with servers etc
  • Microsoft support....you know
Microsoft SQL Server is best for enterprise-level databases for data management. If you need to scale easily there are other options like Azure SQL, etc, but this also works best on bare metals servers. The licensing can get a bit complicated so it is not good for small companies/applications. I also don't think it is the best for mobile applications, etc.
Blake Baron | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We use it as our central data warehouse across the entire organization for most of our data needs. We base our MicroStrategy Analytics software off of it, executive reporting off of it, and use it to house several years of transaction and inventory data. It serves as the central source of truth.
  • Is reasonably responsive even when thousands of queries are executing at the same time
  • Provides an end user experience that allows for intuitive use of structured query language coding
  • The database explorer is intuitive and easy to use for SQL neophytes
  • This is probably a sys admin setting, but it forces me to reset my password every month
  • I've heard the enterprise edition is quite costly
  • If we want to do anything substantial with it beyond simple storing and reporting, we often need to hire consultants
As long as my colleague that I'm recommending Microsoft SQL Server to has an unlimited budget, it's great. Truly best-in-class enterprise-wide data warehousing and reporting functionality; Microsoft SQL Server is the real deal for robust reporting. It's best suited for a Fortune 500 company that definitely has the budget for IT sophistication.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Over in IT we use [Microsoft] SQL Server as our primary RDBMS across the entire department. We have a handful of legacy oracle databases which are yet to be retired and are planned to switch over to [Microsoft] SQL Server. [Microsoft] SQL Server is the database behind all of our software application systems essentially and is how we maintain and store all of our application data.
  • Extremely reliable
  • Great interface via SSMS
  • Fast operations
  • Atomicity
  • A better debugging experience
  • More built in support for logging
  • Better diagram generation
[Microsoft SQL Server is] very well suited for transactional systems, less suited for big data querying and analyzing.
Score 10 out of 10
Vetted Review
Verified User
It is used as a back-end database engine for front-end client databases. Client is installed on user computers and it connects to a Microsoft SQL Server server for data.
  • It supplies a quick and easy way to analyze raw data when troubleshooting.
  • It gives the ability to easily create non standard ad hoc reports for clients.
  • It provides a standard platform for trouble shooting when we need to bring in engineers with advanced skills to solve problems.
  • It provides great tools for testing and development off line.
  • Configuration of the environment to create compatibility and restrict resource uses.
  • Configuration of connections in configuration manager.
  • Connection of data to other Microsoft products like Excel.
My ability to support the recommendation with skills I have gained using Microsoft SQL Server. My ability to provide Microsoft SQL Server queries and stored procedures to others when supporting Microsoft SQL Server in an environment. Ease of moving data into Microsoft SQL Server. It does present problems when importing data from older versions or other sources and takes advanced skills in many cases. Installer is a bit baffling at times and you have to just know from experience what to check or uncheck in the process. Needs a better way to determine what version to use, where and with which licensing mode. Express version often fails for unexplained reasons even though the environment, data size, number of connections.... all are within spec.
May 25, 2021

MS SQL Server

Score 8 out of 10
Vetted Review
Verified User
Incentivized
For the uninitiated it is first important to point out that many programs use a Database at the back-end and the end-user will be totally unaware of that fact. So Microsoft SQL Server is a Database software. You (or the program you use) can enter all the needed information and then retrieve it when needed.
  • Holds data tables
  • Filters information quickly
  • Integrates with many programs
  • Installation is pretty complicated
  • Needs professional maintenance
  • Costs a pretty penny
Some programs just require Microsoft SQL Server as the back-end Database, but if you have the choice I would go for one of the open-source free alternatives.
If you have a big base of Data, for instance, your customers' contact information, each customer's own detailed contract and layout, their tickets and service hours. You want to store them all in a organized manner and be able to retrieve any information quickly. That's when you use a Database of any kind and Microsoft SQL Server is one such Database programs which does a good job.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Microsoft SQL Server to provide a platform for our field users to input data for multiple purposes. We store contract data, financial data, time entry data, customer survey data among other data. Microsoft SQL Server gives us a single source of truth for a lot of our reporting. This allows us to have confidence that we are recording and reporting out accurate data.
  • Integration. We use PowerBI and Crystal Reports for our reporting and it integrates seamlessly with either.
  • Ease of use. Easy to learn and use. (Not the language - but the application)
  • Protection. Easy maintenance and backup options.
  • Licensing. Can be sometimes confusing layers and expensive.
  • Efficiency. Can be memory intensive on larger tables.
  • Server maintenance can be intensive as well.
Microsoft SQL Server has so many ways to integrate data from other platforms and sources, and available tools that it really is versatile enough to handle almost any need. There could be cheaper alternatives out there if you only have a minimal amount of data. At the same time, the cost can be high for smaller companies looking into big data capabilities.
Salvador Orochena | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I currently provide consulting services to various clients. These clients use [Microsoft] SQL Server as the database for there financial system and CRM applications in addition to using for reporting and ETL processes.
  • ETL using SSIS to automate processes
  • Reporting Services to offer SSRS reports as a standard reporting interface
  • Data Analysis using stored procedure, views and transformations
  • Connectivity/Integration with other applications through ODBC, Linked Server, etc.
  • Simplify licensing
[Microsoft SQL Server is well suited] as a comprehensive solution as transactional database, data warehouse, analytics, reporting and ETL. Able to communicate with Azure database environment.

If you use other Microsoft applications, it integrates well such as Excel and Access.

If you have limited resources to support and maintain environment this may not be ideal compared to a managed service or SAAS solution such as Snowflake.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Microsoft SQL Server is our organization's main Database Management System and is the primary back-end server for most of our critical business applications. It's a general requirement that any new application we implement has to operate on SQL Server, if it requires a database back-end. We have a great dependency upon SQL Server and it has not disappointed us.
  • Easy to use to set up databases
  • Reliable clustered instances
  • Maintenance plan wizards
  • Good UI with Management Studio
  • Good BI tools out of the box with SSIS, SSAS, and SSRS
  • It could use more/better templates in SQL Server Profiler
  • Lacks error avoidance tools when working in different environments (DEV/TEST/PROD). That is, preventing some code execution against PROD, for example.
I have used Microsoft SQL Server in one flavor or another for two decades. It has always been a reliable database management system for running anything from custom, in-house applications to business critical Enterprise Resource Planning systems. There is also a broad SQL Server ecosystem available on the internet, which is helpful for development tasks, training and troubleshooting.
John Ramírez | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
This is the database engine we use for our own systems and for our clients. So we use it internaly and externaly, to store all the information we need to have control of.
Also this is the source for different process and reports, outside the database sich as Power BI.
It helps a lot with the database storing, since it is very easy to use and manage.
  • Safe to store and query information
  • Query optimization
  • Scheduled jobs and tasks
  • Easy to code.
  • Maintenance procedures
  • External data sources
  • Support and chatting
Our companny is a Service Desk, and IT Support supplier. We have different needs regarding information, ticketing systems, clients systems and also our company internal information such as HR related.
We are capable to keep the information always available around the globe, also this is kept in a safe way.
We have our systems working on several countries, and the response time, is always excelent.
Lisandro Fernigrini | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We use Microsoft SQL Server as the DB option for the commercial back-office modules of our MLFF (Multi-Lane - Free Flow) Tolling solution. All the commercial back-office (from Customer registration to involvement and payment handling) relies on Microsoft SQL Server databases. Other vital components of the entire solution, like Security and Vehicle Management, and the Reporting environment also utilize Microsoft SQL Server.
  • Microsoft SQL Server is simple to install and configure.
  • Many advanced options like Compression and Partitioning are available with no extra cost, thus reducing the overall TCO.
  • Partitioning does not provide as many options as Oracle (like Foreign Key partitioning, list partitions, hash partitioning and sub partitions)
  • The default READ COMMITED isolation level block readers, so it is important to use the READ_COMMITTED_SNAPSHOT option, that should be default right now...
I've found Microsoft SQL Server a robust and affordable solution for most OLTP scenarios, starting with department solutions up to enterprise-level systems. There are many advanced features (like compression and partitioning) that correctly implemented provide huge benefits on performance, reducing hardware requirements and costs. The default locking mechanism can be a problem for systems with high concurrency if the READ_COMMITTED_SNAPSHOT option is not selected.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
Our business's in house desktop and web applications run off a SQL Server database. We have used it (and abused it) for 12 or so years now. I don't personally have experience with other databases (a little MySQL) but so far I haven't come across a scenario where SQL Server has been lacking, and that is coming from someone who advocates putting the business logic in SP's (OK, let's not start down that path...).
  • Stored procedures, efficient and so much easier to update business logic when under pressure!
  • High availability always on groups (since 2012), is pretty easy to set up and just works - has been an absolute savior on 2 server failures.
  • Fairly straightforward to administer out the box as it were (but this can be enhanced see below).
  • So widely used that someone somewhere has probably faced the same challenges that you have so [to] find a guide, solution, suggested path is relatively easy (not strictly a SQL server thing but makes a massive difference knowing that you have access to huge resource with a well supported well adopted piece of software).
  • Very well supported in terms of third party software to enhance administration (backups, performance, etc.).
  • Enterprise is unbelievably expensive.
  • Not tolerant of bad practices and poor query writing, really shows up when you do it badly!
  • Deep insight into what is happening with query performance is not especially great (but as mentioned in the "Pros", software support from third parties does cover this).
I have grown very fond of SQL Server, as I say I don't have a lot of experience with other relational databases, but I haven't hit upon a limitation within our use cases. Its TSQL is a pretty easy (scripting) language to pick up, stored procedures are very powerful and offer efficiency and security, not to mention allowing for quick changes to logic can be a real time-saver.

I will say I have had limited joy with text search (full-text indexing) to achieve better text searching results, but that's probably done to me. It's the one area I have never really managed to find a great guide on though.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
We utilize Microsoft SQL Server as the database for our Epicor Prophet 21 ERP system. It is used by all of our users to process the products that we sell, the potential customers for our Sales staff, and our purchasing department to order from suppliers. We also utilize SQL Reporting to create custom SQL reports for Management and end users. Microsoft SQL Server helps address the ability for management to easily query and access necessary business metrics. Customized SQL Server views and stored procedures are used to automate management tracking and customer contact. Since SQL Server is a widely-used database, numerous third-party tools that we use, like Pipedrive and Google BigQuery, easily interface with our data.
  • Easy to create queries to return specific, filtered data
  • Interfaces with many third-party tools, like Pipedrive and Google BigQuery
  • Provides easy mechanisms to backup and restore data
  • SQL Reports are easily created and customized
  • Better exporting of SQL Reports to multiple formats
  • More Tool Tips for some of the less familiar options
  • More backwards compatibility for older software
Since [Microsoft] SQL Server is a widely-accepted and popular database format, it is well-suited for smaller and larger environments, thanks to the different SQL Server versions available. SQL Server installation and configuration is fairly straightforward, and can be installed on different hardware, depending on needs. It may be less appropriate where simple database usage is required.
John P. Maher | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I have worked with Microsoft SQL Server on many projects. The most recent was as the backend of an ERP system. The nature of an ERP system involved the entire organization from the shop which would use it to get the BOM (Bill Of Material) to build the parts to QA to check the parts to Purchasing to buy the raw materials to Sales to sell the parts to Shipping to ship the parts and even HR.
  • When properly maintained results are returned quickly
  • Backups and restores can be done quickly for testing
  • Support for common data access methods makes coding less painful
  • SSMS (SQL Server Management Studio) really helps IT in database activities
  • Debugging stored procedures can be done better
  • SSMS could be integrated more efficiently
  • Tasks that require many steps could be either streamlined or at the very least remember the data entered for each step
Microsoft SQL Server is a good database and works well in all the situations in which I have used it. Although there are things that can be challenging or unintuitive but once they are learned you quickly forget how difficult or unclear they are. To be fair, other databases exhibit the same difficulties and overall, SQL Server provides great service in any situation where a multiuser environment is required.
Score 7 out of 10
Vetted Review
Verified User
Incentivized
Microsoft SQL Server is used in our organization to store data, run analyses, and produce reports using data from our web-based application. It is mostly being used in the data analytics department and it allows the team to work on projects together and integrate with other software used in the organization.
  • UI is user-friendly, making integration easy for all members of the team.
  • It is easy to set up and teach to new members.
  • Good support with third-party software.
  • Cost can be expensive.
  • Some learning curves for users transitioning from other services.
If security and consistency is important then Microsoft SQL [Server] might be a great option as your DBMS.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
Our company uses MS SQL Server to run jobs, store data and generates reports. Our team is supporting two separate companies and both use MS SQL Server. One is for storing data and running SSIS jobs for app and reporting purposes. These are company-owned servers and we are hosting other companies to provide service, application and hardware support for them.
Our company maintains these servers and they are being used by different departments, also internal company-wide. Business problems that we commonly encountered are mostly connection issues. These are basically a between network, database and applications connecting to MS SQL Server. The MS SQL Server support is easy to get in touch with when we are having issues with the application itself.
  • Maintenance, SQL server is easy to maintain.
  • User Friendly, Easy to use and understand.
  • Access, user access, and administration are very straightforward.
  • Application, it is easy to setup and provide service.
  • Can be used in small and enterprise sized clients.
  • Support cost, need to pay for support.
  • Compatibility with other new technologies.
  • Reporting capabilities.
  • Licensing, it is a lot of work to get licenses renewal
I think it is best used in small businesses if you will be just paying for the hosting platform. Building your own server, maintenance, support, and application will be very expensive. Getting support solutions from other companies will be the best option since you will not have any problems setting up and will have the database and reports ready for you. In the enterprise setting, creating and building will only have a licensing issue if they can provide and maintain their own servers.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
My department uses SQL Server (and Azure Data Studio, increasingly, but still primarily SQL Server) for database management and analysis. Other departments use it as well, including our QA team, to verify the expected output of data manipulation or the functionality of changes to the code base. It's a pretty standard tool at this point.
  • Query analysis and execution plan details - You can see indexes you may be missing that would (if used) possibly improve performance of your stored procedures and queries.
  • Data storage - It's easy to restore and back up entire databases and to set up automatic jobs to do this.
  • Scheduled tasks - You can plan health checks or updates to data, or reports, from the Jobs tool.
  • Unlike Visual Studio, there isn't a built-in or out-of-the-box way to format your SQL scripts/queries. You can easily install plugins and extensions to do this (paid or free) but it would be a nice-to-have.
  • Occasionally it's not obvious from a query execution plan what piece is causing the most bottleneck, and even then, side-effects of implementing the suggested index(es) aren't always obvious.
If you're a developer and you do any work with retrieving or updating data, Microsoft SQL Server is a great choice (assuming you're working on a Windows machine - although I think it's easier now than it used to be to connect to SQL Server from other operating systems). It's fairly straightforward and the learning curve isn't terribly steep, and if you put the time and effort in you can learn a lot about performance tuning and best practices.
Quentin Goin | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Incentivized
I consult for system and data integration projects. Many of my customers use SQL as their data management and storage system. During integration projects, I will also use SQL to store information that I need later in the integration process or for reporting purposes or auditing.
  • Storing data in a de facto standard relational database.
  • Industry proven connectors to the data.
  • Options for hosted (Azure) to on-premise.
  • Options for scalability from SQL Express to SQL clustering.
  • Developers have their change list, however, it does what I need.
Large to small amounts of data that is logical and fairly predictable type of data. It provides a way to see the data and access it in a logical way. SQL provides the system for database architects to create their own database as efficiently or not so efficiently as they wish. The platform is flexible.
SQL is not as well suited for fuzzy data storage or data lakes.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
SQL Server is our go-to database for both on-prem and cloud database needs. We are running on-prem for 3rd party, custom applications, and the enterprise data warehouse. The Cloud is great for custom applications, as well as beginning to migrate to a data lake structure with Azure SQL DW. Other than embedded databases in a few apps, it is the only RDBMS technology we leverage, although we do run several different versions and editions (Azure SQL DB, Azure SQL DW, SQL Server 2016, 2017).
  • It's easier to manage than other RDBMS.
  • Good, mature, in-the-box interface for both development and administration.
  • It has a fully extending feature set for managing Azure SQL DB to SSMS and/or Azure Data Studio.
  • It's simplifying security/access setup for Azure SQL DB.
I have been using MS SQL Server since version 7, and it has grown significantly in that time. While in the early days I would only grudgingly consider it for departmental level use, by 2005 it had reached enough of a level of stability and reliability that it was a good option for small to mid-size enterprise use. Today, I consider it the premiere RDBMS for virtually any scenario, particularly considering the number of options available. Microsoft's continuing pursuit of separating compute from storage also seems like the right direction, and allows for the compute engine to leverage big data scenarios as well, where the data is sufficiently structured to support utilizing external tables. This provides for use of familiar SQL tools against outsized data sets that do not fit easily in the RDBMS storage paradigm.
Keri Schneider | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Incentivized
I use Microsoft SQL Server to write SQL queries for my healthcare organization to do reporting for national quality metrics. It allows me to write efficient, fast queries that export nicely to Excel.
  • Error logging and indicators
  • Colors keywords
  • Allows for easy formatting
  • Allows for multiple tabs
  • Allows for multiple subqueries
  • Needs more specific error messages
  • Sometimes it seems "buggy" with the predictive text
  • Needs an in application help resource that is easier to understand
Microsoft SQL Server is well suited for Excel exports of data for on the fly reporting. It smoothly incorporates subqueries that allow large pieces of data to be joined together without bogging down resources. It can also easily be used in other applications. For fancy visual effects or pictures it is not well suited. It is a very "bare bones" application.
Score 9 out of 10
Vetted Review
Verified User
Incentivized
In our database department, we use Microsoft SQL Server for storing data, data aggregation, and manipulation. We use Reporting services tools for creating, managing and deploying reports for our clients. For creating a report definition I personally used Report Builder which makes defining data source connections, queries used to retrieve data, expressions, parameters and others extremely easy to perform. We also try to improve the performance of stored procedures, user-defined functions, and triggers by learning the execution plan in detail. One of our clients has a web app for an insurance company and they have a large amount of data stored in the Microsoft SQL Server database. Our goal is to improve performance from queries that are used in that web app, so we try controlling execution plans with hints or adding indexes. In cases when we meet a new client who already has some database storage then we use replication technology for copying and distributing data and objects from one database to another. Besides that, we also help our clients to build parameterized queries in order to defend from SQL injection which is one of the most common web hacking techniques.
  • It offers a lot of functionalities, such as Reporting Services, Integration Services, Job Scheduler, Resource Manager, Query Analyzer and Profiler, etc.
  • You can connect it to Active Directory if you so desire.
  • The price of the enterprise version could be a little lower and also licensing should be more understandable.
  • There can be problems when connecting with software that is not owned by Microsoft.
When a client is working in a .NET environment and he is developing a web application then it is advisable to use Microsoft SQL Server as a storage solution. Also when some company wants to store a large amount of data then Microsoft SQL Server is an extremely good solution because it is a very stable and maintainable database option. But in cases when someone wants to make a small website or application that stores a small amount of data then it is probably better to store it in some open-source database which is also free to use. When some company relies a lot on analytics then SQL Server is the first-class solution. A scenario where it would be less appropriate is when some startup doesn't have much money for starting and at the start they don't need some very professional RDBMS, then they could use something like MySQL.
Armando Peña | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We are using Microsoft SQL Server to store the data of many commercial and internal software applications: SAP Business One, our Point of Sale system installed in more than 60 branches around the country, several web and desktop applications, and our data warehouse used across the company. That represents thousands of transactions per day.
  • Easy setup
  • High performance and flexibility
  • Data recovery
  • Linked server functionality
Microsoft SQL Server handles a thousand transactions very well, but a bad database design can turn that into a nightmare. The tools that it brings are great integration services. The analysis services and reporting services are very flexible and productive. It is integrated very well with Microsoft Office. In terms of programming, the support is great.
Michelle Sollicito | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We currently use SQL Server in Azure which makes management easier, though I have used on-premises SQL Server for many years, many versions. I am Microsoft certified in SQL Server 2012 and 2014. As a software developer I like the way SQL Server is easy to program against -- especially when using Entity framework or Entity Framework Core as the middle ware. As a database administrator I like the fact that SQL Server is truly relational, which makes it much easier to model business objects as data tables and to manage Referential integrity, locking and consistency. I like its ability to help with performance scaling via pre-compiled queries, stored procedures and triggers. I like its ability to help with scaling via sharing and replication. But above all I love SSMS (SQL Server Management System) which brings together all the tools in one place with easy access to query plan tools and analysis tools as well as SSIS / SSRS allowing integration of data with other systems and generation of reports.
It has matured over the years into a tool that makes life easy for those architecting or writing systems.
  • Modeling and Schema creation
  • Query optimization tools
  • Integration with coding tools via Entity Framework etc.
  • Analysis, integration and reporting tools
  • Better handling of blobs so that they do not slow down queries (lazy loading by default perhaps)
  • Automatic Migrations -- migrations are complex right now, tools that make it easier would be useful
  • Cheaper!!! It is too expensive, forcing many people to go to datalakes/s3/NOSQL databases when they do not really want to
Green field sites where you can start by modeling the business objects up front and getting the relationships right, the integrity right. Database First Entity Framework environments.

It's not so good for Code First or even Model First Entity Framework because typical coders do not really understand data modeling to the degree necessary -- and later on they suddenly find a whole load of duplicates they did not expect -- or a relationship that does not make sense, constraining what they wanted to do.
Score 10 out of 10
Vetted Review
Verified User
Incentivized
We are a Business Intelligence shop utilizing the entire Microsoft Data Stack. We use SQL Server versions 2012, 2014, 2017. We are also currently evaluating 2019. Our entire organization also uses SQL Server. In our department, it is used to ETL data in (via SSIS), store it into a Kimball Data Warehouse, do reporting off of it via SSRS, and then provide self serve analytics to our business users via SSAS. The best thing is that SSIS, SSRS, and SSAS are all included with SQL Server!
  • Great integration tools via SSIS.
  • Great reporting tools via SSRS.
  • Great analytics tools via SSAS.
  • Latest versions (2019) really push the envelope forward on automatic query optimization.
  • Need to be careful on licensing and features. While they have done a great job in 2019 to make features available in standard edition, a lot of use cases may require the more expensive enterprise edition.
  • SSIS and SSAS doesn't play well with source control.
  • There is no "Data Virtualization" (Not talking about PolyBase) You should be able to spin up a clone of a database with minimal effort and storage space. No reason to have to pay a secondary company for such a vital feature!
It doesn't matter if you are doing OLTP or OLAP. SQL Server is just great. And when you compare the cost of this vs other paid DB products, like oracle, the cost is drastically cheaper! Unfortunately, it still is paid so it is hard to start using off the bat for newer companies. They will typically go to Postgres and then migrate over to SQL Server in the future. Microsoft is working hard to lower this barrier to entry. But it looks like it will take some time.
Return to navigation